SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001211s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 481007 LIMIT 1 [ RunTime:0.000485s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 481007 [ RunTime:0.002835s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1007986,878023,162194,213822,72382,89084,413139,319608,402688,769574,779792,261803,925086,605865,642033,571942,261547,631010,371030,773101,346137,516697,700737,853610,261424,1037589,597741,419243,329823,167595,119840,50702,801899,895568,722519,447368,26327,85713,250322,11827,380090,520716,705754,732939,154079,949858,841614,153790,956945,671421,946624,144281,219921,95991,791983,82698,1001611,377540,132175,372943) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001258s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 481007 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000613s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 481007 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000582s ]