SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 157570 LIMIT 1 [ RunTime:0.000634s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 157570 [ RunTime:0.001591s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (109226,448016,530926,524527,202303,775253,262143,744209,634926,489279,61360,452760,655417,207484,371852,67707,524507,513671,885938,656921,167449,20338,413063,764606,176821,619855,931255,370241,19953,486429,591251,498575,736563,641699,980731,813913,699946,648347,500720,124914,998740,584119,915575,265178,716027,976523,1013197,1042679,18919,140771,449396,487458,157125,124029,227756,608749,324095,958315,294634,271003) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000987s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 157570 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 157570 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000579s ]