SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001323s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 310692 LIMIT 1 [ RunTime:0.000874s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 310692 [ RunTime:0.002060s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (811939,333635,901140,943563,151778,1012684,686174,1022264,784658,469783,1013970,898696,180915,312238,602893,656520,675735,289141,274330,404622,387378,500901,391663,879884,127623,129553,315438,617811,608246,87230,290625,458538,75902,464003,234601,789015,82966,736084,307999,453566,150372,504191,952285,812544,139676,892886,658455,751984,107721,793917,190836,242762,1013585,652340,605635,727546,689412,422394,447410,520455) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001042s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 310692 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 310692 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000583s ]