SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001296s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 436095 LIMIT 1 [ RunTime:0.000402s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 436095 [ RunTime:0.002660s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (650345,721534,339145,331951,141103,920158,299817,180194,381953,275020,863523,535704,117824,338560,827404,249887,373397,462985,605158,654390,179435,890176,558330,1039839,470141,399087,207279,801418,714306,58058,127835,962374,348405,841779,317737,100475,257331,598262,516683,841514,856007,860025,334059,141319,109537,300039,156914,853376,367664,711552,92549,575730,302078,945812,897750,467410,662759,924531,451527,1031251) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000951s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 436095 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000725s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 436095 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000602s ]