SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001112s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 140208 LIMIT 1 [ RunTime:0.000300s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 140208 [ RunTime:0.001713s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (597710,915579,434950,145971,999436,730322,615879,271582,826193,118108,439189,620347,915772,424100,193460,352492,636506,973188,504658,543170,1013071,551773,305598,368845,667326,633442,897546,573466,758140,614893,210582,915824,423840,176258,676960,1018451,2215,127991,812957,894060,875707,903019,72449,820596,618072,258364,938195,334084,723842,228086,618026,824406,392013,777658,238371,283177,300660,430408,60709,89044) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001063s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 140208 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 140208 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000513s ]