SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001151s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 427305 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 427305 [ RunTime:0.001747s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (556338,919596,315965,372969,505372,510915,602414,272920,881510,680628,959041,1044081,280053,122621,133012,529760,203309,202577,192760,499299,691579,240933,1009939,168713,743233,7035,66132,178228,1027830,714661,863941,470077,410437,63450,526910,231600,618111,705740,607627,507848,666996,790900,163149,144255,43482,28266,596378,558286,915252,983248,302113,10420,924646,443728,588241,534227,967940,130930,166093,147591) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001218s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 427305 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000451s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 427305 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000454s ]