SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001173s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 278831 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 278831 [ RunTime:0.001826s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1016606,1032326,1020361,150026,314861,967981,300013,300614,395050,758174,71320,488987,428267,72832,622908,542933,182127,608287,662551,582261,600485,91252,1012227,270809,79104,840613,827811,93388,825503,560195,1000552,763563,107900,137911,822199,629394,1042115,850634,712472,224320,208112,546672,383208,549288,991484,133163,543341,384404,315403,73655,52992,434780,123750,821170,187891,365787,989592,522277,757163,883759) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001029s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 278831 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000458s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 278831 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000454s ]