SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001125s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 502646 LIMIT 1 [ RunTime:0.000331s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 502646 [ RunTime:0.002215s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (951171,554500,257460,201274,510720,885965,760873,290487,624959,572762,1041927,214149,358274,379858,1040414,130829,314515,907263,818391,665612,590976,122254,38719,725424,645979,665439,682174,516595,684777,680982,582830,691517,514643,897156,207163,977494,171690,398213,915460,543224,330951,691885,256750,656812,1031162,503320,726641,678760,839492,643013,168873,97251,728431,896555,274411,756101,352014,886459,663369,853274) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001086s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 502646 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000337s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 502646 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000496s ]