SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001156s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 494971 LIMIT 1 [ RunTime:0.001790s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 494971 [ RunTime:0.002690s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (390338,149396,244877,402674,397138,55308,430391,503024,562359,999317,377704,3765,1001598,41875,647002,425120,821457,483868,182915,557099,968706,101193,170928,963856,471416,882161,842869,711144,497509,695729,818955,631079,889064,657143,700977,143436,243972,841897,150101,504024,60319,566838,499714,528915,323868,80276,672536,1039109,851504,108623,15339,669826,169893,733353,320724,143812,9558,657296,1021454,78735) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001068s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 494971 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000346s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 494971 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000469s ]