SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001194s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 407219 LIMIT 1 [ RunTime:0.000420s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 407219 [ RunTime:0.004845s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (803377,911063,879967,951713,554388,1009695,1003177,948613,1045730,456801,107849,253326,867061,301957,188954,12093,182929,70807,171546,243757,633864,381473,215939,791934,443535,539276,500472,203375,1001251,688389,569505,370042,508042,887628,874184,477533,444543,541952,49034,233789,792699,156050,85799,932114,932679,143327,720885,113243,549878,66862,940957,920129,273680,716079,799080,226630,546701,415200,818295,165984) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001882s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 407219 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000444s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 407219 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000539s ]