SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 451755 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 451755 [ RunTime:0.002059s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1016779,61047,523448,934422,1016437,694289,594804,102425,411570,177648,912898,855008,105395,938920,402926,902670,590289,530485,440471,285276,559476,571104,823946,855539,207865,923132,273914,318246,205709,580582,266337,440347,588009,500800,228981,208466,57910,856228,270527,146237,936210,701640,804934,328141,711409,437478,117675,643861,164170,856989,900087,771991,243869,754843,662745,876244,183397,753769,960306,93631) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001054s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 451755 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 451755 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000573s ]