SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001170s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 407306 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 407306 [ RunTime:0.004144s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (118885,235189,601297,169849,258815,50167,153599,573948,60718,776986,612938,341093,447247,150050,636497,108155,702063,672526,390251,861631,1022590,148760,514723,271171,702152,791691,75203,281005,1046202,392543,668569,352605,481594,657640,363927,230292,908061,410498,340810,702171,677322,906811,725251,657486,392894,816520,56492,943350,855362,605540,588777,388779,397565,721591,833758,598024,277731,148377,634438,149240) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001577s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 407306 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000647s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 407306 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001981s ]