SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001740s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 241114 LIMIT 1 [ RunTime:0.001383s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 241114 [ RunTime:0.002699s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (779922,581024,279668,604118,564359,849387,954958,761963,1000781,31974,998296,317730,885924,269585,1034601,308316,931570,603187,33224,98758,121807,963200,338645,848646,691368,180854,487440,424826,92387,1016865,436993,670039,322394,867621,734347,642486,662500,537916,930297,238387,774697,576448,414278,664836,352328,325175,640359,483504,716177,667577,617279,785687,494564,759575,539521,276047,350278,670721,918248,238475) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004530s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 241114 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.005217s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 241114 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000711s ]