SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001183s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 335767 LIMIT 1 [ RunTime:0.000308s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 335767 [ RunTime:0.001625s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (540121,352003,147211,1126,424556,246974,979093,581769,429210,614380,300352,1036277,28568,992429,555927,580812,359614,141218,650202,726060,370946,397161,974303,326998,544230,755085,645639,477612,979630,422724,289678,988440,814475,590216,308254,979380,358478,941028,28783,42771,442536,94488,349271,737465,652557,972328,647958,181591,106022,918921,243302,737830,713215,818998,196461,793828,19738,458303,211868,738150) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001071s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 335767 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 335767 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000585s ]