SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 340945 LIMIT 1 [ RunTime:0.000343s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 340945 [ RunTime:0.001530s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (512899,798504,709268,290320,161280,739094,606403,311784,292333,888438,901283,652854,4157,638492,238159,656724,379558,969289,846109,85853,1038920,582960,979932,359926,656106,631282,21287,113251,683928,230345,859071,286394,336742,3023,318120,965945,400692,175656,102337,523825,629410,944344,151591,545979,463221,211095,967289,747975,36753,9402,293182,898052,891242,1027651,268190,632965,324044,152990,960707,464405) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001024s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 340945 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002401s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 340945 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000538s ]