SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001396s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 454962 LIMIT 1 [ RunTime:0.000482s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 454962 [ RunTime:0.001810s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (808531,199616,752668,269952,405194,1025476,780111,134575,758641,753491,285945,209442,920288,503690,366686,161724,333523,798451,604348,1043928,372859,975795,343387,832212,575257,675072,746211,61654,256494,141177,986476,631131,57378,241231,286523,825423,531966,456039,997060,572570,275573,187596,789218,171799,920477,569730,43920,599814,852918,982815,655151,645689,872950,289080,80772,512489,386102,54652,144428,630364) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000943s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 454962 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000346s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 454962 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000518s ]