SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001260s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1019854 LIMIT 1 [ RunTime:0.000399s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1019854 [ RunTime:0.001679s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1028486,160179,423591,117738,753416,727188,618175,593691,690031,230303,788284,993871,719496,862968,447177,631955,795690,149449,151602,941369,530865,512537,867586,91420,996697,796968,43327,604521,994690,444437,477034,480716,744909,170196,752607,256591,134225,905875,151693,697523,114905,472944,594377,902126,657135,186375,132782,505624,235840,985513,401018,129391,684803,399485,651124,123757,684172,802288,305641,540045) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001001s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1019854 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000412s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1019854 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000562s ]