SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001993s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 387040 LIMIT 1 [ RunTime:0.000384s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 387040 [ RunTime:0.002111s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (536037,140404,452664,944542,637566,143053,50891,46775,735163,499976,908794,569348,181010,1010044,491534,621303,243637,103232,984860,865934,443221,699264,875428,696024,951726,243317,405292,225339,485153,72907,776535,275586,764065,78494,630318,947560,818872,292591,752919,1039264,524513,1027353,848241,676374,1007944,536937,536582,376951,506387,101373,321672,537350,386056,974086,551172,324852,251197,399978,724972,558227) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001021s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 387040 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000440s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 387040 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000573s ]