SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001476s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 591144 LIMIT 1 [ RunTime:0.000415s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 591144 [ RunTime:0.001858s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (283906,961575,165554,284256,717004,1019623,902816,783592,666112,785804,427862,56467,926004,465531,6200,273459,183696,753605,94848,1001858,1000025,867186,82481,1040960,611460,980877,120466,781936,349154,584143,349870,670927,619921,68001,198985,975640,234282,375347,661698,61695,96227,483605,476681,780947,501749,360323,390558,832622,690359,1032605,56977,731057,539120,126359,965611,320203,757613,703084,626382,827986) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001247s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 591144 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001413s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 591144 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000632s ]