SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001241s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 201210 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 201210 [ RunTime:0.008501s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (396834,110555,309371,718979,44339,503384,675536,1005034,710964,773849,140361,511973,487691,498987,674234,967621,589657,337333,669367,336020,386646,218452,214357,863194,257300,172916,380766,69961,939161,691240,352025,917948,55868,696983,355697,875495,511659,373152,739833,8714,15114,453593,729486,798143,63112,837191,664123,598808,608322,918910,440462,56492,55522,294991,913657,896592,37690,271832,533036,116384) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005892s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 201210 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000926s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 201210 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001284s ]