SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001197s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 689267 LIMIT 1 [ RunTime:0.000346s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 689267 [ RunTime:0.003325s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1023833,580821,598553,504648,331223,652807,57141,50264,640973,288043,338355,6236,853823,666664,748169,423630,274909,548145,735557,610709,337199,182128,510249,1015842,864596,1005857,641183,930862,663888,187830,741620,840872,770065,563966,636800,650423,192658,205019,588306,378267,203290,927603,42518,128002,380487,958376,164315,688867,628272,444979,862732,838350,1039702,349667,970958,999447,431207,495496,514734,482563) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001158s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 689267 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001481s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 689267 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000539s ]