SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001226s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 420048 LIMIT 1 [ RunTime:0.001822s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 420048 [ RunTime:0.001656s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (969135,674755,584825,799513,454402,400684,975519,58806,250921,774799,907635,16348,673260,218754,1009241,443344,94229,804491,712222,663092,215197,311697,268234,751635,885398,109254,845335,447105,663693,14954,346350,236882,667244,321536,613323,543151,731783,604405,751196,173016,884472,297054,435386,245623,126683,915721,958133,1027688,75996,801854,526852,828803,831165,21096,295159,493030,452727,706568,593195,1023956) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001073s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 420048 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 420048 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000568s ]