SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001247s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 538704 LIMIT 1 [ RunTime:0.000336s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 538704 [ RunTime:0.001645s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (322921,468020,603770,375674,338024,596194,1007861,942785,829791,576299,395503,449231,525954,592905,86181,714118,916663,44826,284250,410497,434861,471546,765294,465187,951836,566713,1018081,242138,393403,963236,297891,984603,237776,345353,266652,546994,642266,131165,737730,341515,1004389,273823,709166,900036,542970,708680,851189,15203,328784,232338,635027,300332,649521,270146,87742,413522,245427,716657,501671,526050) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005157s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 538704 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000540s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 538704 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000662s ]