SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001165s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 404319 LIMIT 1 [ RunTime:0.000402s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 404319 [ RunTime:0.001689s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (550597,617100,1009108,381583,462253,428292,960930,380090,476120,483842,696826,201290,178933,976830,240647,366631,1012931,843849,64359,900427,1011756,784399,102758,730823,1021009,636152,705688,155802,181458,822465,779661,852801,633168,243866,760708,687907,879335,782379,129199,643230,299163,421460,477775,348556,457099,527013,1006141,973471,137011,252980,259276,376933,422607,358062,373083,772366,472227,379109,795285,560037) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001607s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 404319 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000549s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 404319 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000609s ]