SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001355s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 807218 LIMIT 1 [ RunTime:0.000427s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 807218 [ RunTime:0.001607s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (413075,415585,55550,218764,357351,811499,722796,1020248,386754,922006,145872,75826,490233,499187,786217,968884,878566,175571,10320,446342,677602,334233,209531,596633,647358,68713,829099,165740,667081,269389,498807,957181,610898,113447,11803,360024,369618,350618,661650,896684,856314,572876,95292,170566,42272,521999,689735,560250,329339,669380,738901,836535,331210,428748,787944,156354,317788,804230,505164,903345) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001039s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 807218 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000397s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 807218 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000582s ]