SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001179s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 423913 LIMIT 1 [ RunTime:0.000371s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 423913 [ RunTime:0.004130s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (750778,149599,883219,300564,363891,823319,1018658,16757,620550,852461,241076,21770,908743,977220,422468,407963,180125,199796,258031,647655,602063,763352,788112,696638,466980,599220,740509,718638,168287,386006,1022752,121924,992722,839267,410438,425955,110510,798506,597323,747650,285467,1043536,207730,267098,61815,920787,632317,201992,901767,670939,63446,20420,616863,978767,448552,770611,608669,1009762,597610,28754) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001168s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 423913 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 423913 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000603s ]