SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001209s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 310404 LIMIT 1 [ RunTime:0.000335s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 310404 [ RunTime:0.001813s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (384900,569195,215726,781830,937702,1032739,1004956,933762,508646,153873,325195,935345,228717,502988,374805,741893,92147,264325,318328,719144,463586,518189,770947,100325,1021165,166930,1017976,25955,572329,869286,55776,579573,862482,171382,696081,402147,536189,686433,933829,235601,787699,813989,615618,791534,890630,457603,155766,512982,761680,282019,413760,381726,843252,108219,275201,723108,648401,931969,2456,897864) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001036s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 310404 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000860s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 310404 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000537s ]