SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001161s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1019334 LIMIT 1 [ RunTime:0.000381s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1019334 [ RunTime:0.006168s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (100009,934100,219122,192748,385449,1003582,956652,777735,170897,116920,452220,412209,981419,726722,355500,337921,364633,141389,745549,470877,165069,687893,264551,977110,222601,268585,462261,333275,39113,381608,92553,793713,180339,1046722,690299,40199,827734,784179,881215,209371,803659,955536,1027951,503681,182892,868809,752784,1011066,149036,523655,34467,601854,290691,225075,283895,84605,185941,592103,54731,901978) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001145s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1019334 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000430s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1019334 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000556s ]