SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001146s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1040143 LIMIT 1 [ RunTime:0.000314s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1040143 [ RunTime:0.001578s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (995945,273031,1004999,636103,513257,224382,709393,117922,24421,251287,614206,225859,907072,863094,904326,854028,988680,752767,312789,8976,863832,797744,951564,559324,806396,162798,543722,320471,555508,823665,56769,142584,821577,334316,301575,926523,436021,230427,367523,573109,452110,1037754,439104,659814,653199,144764,477720,667665,466545,790594,727724,587870,789200,599064,277167,112706,387318,403697,1038752,140062) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000911s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1040143 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1040143 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000399s ]