SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004233s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 596423 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 596423 [ RunTime:0.001756s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (280650,298009,174595,947682,797688,278525,877480,92980,915718,861294,900307,862844,113380,933946,1025262,1002169,779818,171169,371734,430269,248602,828211,835193,280727,78058,206905,784768,931114,863011,1037607,34844,93855,195061,864705,889575,89707,751044,678865,692235,558376,838974,665419,98296,206718,220251,1045934,794666,491942,17942,324147,983425,794295,983545,1025189,365672,358345,486327,489472,67752,968980) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001151s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 596423 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 596423 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000502s ]