SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001264s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 597528 LIMIT 1 [ RunTime:0.000373s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 597528 [ RunTime:0.001694s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (556526,656572,575018,807249,1034986,411220,450852,203242,133873,896016,651956,692052,712222,452438,580333,1030793,497180,941647,571140,782447,728029,377822,602787,152929,324736,14869,1033998,551941,699657,408092,384457,1034808,603003,319311,149812,718226,812267,703680,912490,143439,893820,864921,545677,684568,780308,316251,640236,566012,267707,270681,33373,1043276,619260,212841,232655,477043,289365,600203,13528,368406) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000974s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 597528 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 597528 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000487s ]