SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001264s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1004785 LIMIT 1 [ RunTime:0.000407s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1004785 [ RunTime:0.001766s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (658466,344539,1009134,571175,694284,394457,575319,820658,866078,543482,583911,191541,461499,769023,556124,586350,62914,565639,471577,491755,1031517,559975,119782,807935,166257,980432,213204,182144,696138,1024719,436680,480347,585679,796320,291788,994148,994608,818641,828865,213344,172134,87422,653704,979164,452711,560752,902631,60874,996732,965567,650271,941948,940405,949785,151328,80364,84104,452759,922527,958282) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001131s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1004785 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1004785 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000602s ]