SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001185s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 585591 LIMIT 1 [ RunTime:0.000473s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 585591 [ RunTime:0.005137s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (41342,651066,320525,398262,939217,977954,272716,559199,883574,684241,1014740,433920,802480,660504,685124,539998,600628,860846,210458,17582,500918,213345,727938,138684,533109,178494,315978,687728,719607,390615,548358,209629,415634,644368,691354,840692,251203,799432,385202,769198,854849,117690,270945,961067,143391,529436,225779,652604,643686,1033061,152859,212248,1027664,823196,289800,1028087,678348,972493,15764,965386) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001150s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 585591 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002125s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 585591 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000439s ]