SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002741s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 144681 LIMIT 1 [ RunTime:0.000561s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 144681 [ RunTime:0.002432s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (543128,1025949,131530,580891,250044,1021564,998489,250557,395664,539227,533173,69259,369622,69155,757086,86970,120500,46725,115445,1007593,500745,820293,324024,953735,933659,309080,779784,638247,601344,587768,395034,133709,783415,200945,882596,774740,109198,245452,40970,735686,40405,33515,15063,654727,195481,533220,292471,16834,250042,850030,803276,365795,2731,651756,774832,865369,139308,74100,336273,697290) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001262s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 144681 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000484s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 144681 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000614s ]