SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 442418 LIMIT 1 [ RunTime:0.000344s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 442418 [ RunTime:0.001966s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (462075,52914,178819,758127,139869,971060,464103,726912,158879,454710,261189,802370,100265,480416,472798,1039350,104389,600805,515328,696050,672368,404325,64844,401262,697973,344491,865294,753027,933620,614720,287641,50869,845933,1022070,380837,547913,624886,96185,161889,48678,719683,1031556,131562,398936,354727,331068,200820,224556,564947,973922,512590,1019649,428167,627857,662715,412563,369164,428331,4769,964687) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004275s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 442418 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000464s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 442418 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001230s ]