SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 51801 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 51801 [ RunTime:0.002790s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (498985,178636,474386,781395,511607,429492,830202,968912,235702,545096,287938,874842,31706,267205,410689,972146,303259,1001386,634537,546693,619316,52519,576157,317847,993378,374549,167837,746300,502228,723620,508589,718925,138265,882013,299721,6768,260051,763087,585663,968696,315399,955928,113035,300615,639266,265116,433005,125875,892969,94330,636818,507740,638696,557343,568956,238052,617772,129989,812049,1038582) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001141s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 51801 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000617s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 51801 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000544s ]