SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001192s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 455691 LIMIT 1 [ RunTime:0.000292s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 455691 [ RunTime:0.002056s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (42693,651830,173790,735126,892375,1021980,780737,543016,116265,634070,791676,510903,342585,395889,232094,448384,933118,445455,941810,210087,663766,557583,159624,795090,317645,213247,520659,637660,582326,918329,645998,350178,414152,1009324,1041832,470039,610329,750296,854471,279965,719557,922850,440928,371617,965113,921398,253790,1006599,865638,574943,207496,737249,472324,458027,694215,874846,1048150,925908,869866,255999) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.009813s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 455691 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000405s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 455691 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001068s ]