SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001200s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 803474 LIMIT 1 [ RunTime:0.000400s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 803474 [ RunTime:0.001660s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (258942,592734,1013093,362586,440346,689504,93044,292598,961173,656577,113663,853125,736183,324174,73485,41871,233832,833248,54521,1009615,371750,1004308,676637,138156,941528,515154,343033,522021,71556,900178,70689,198081,116151,441575,116457,767436,999770,155141,954117,726483,561006,609667,105167,393152,427402,375280,903158,255587,145341,373164,352993,725975,3630,330205,669896,88535,442567,635067,199597,320554) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001090s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 803474 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 803474 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000619s ]