SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001101s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 507581 LIMIT 1 [ RunTime:0.000327s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 507581 [ RunTime:0.002513s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (628168,467720,869635,25102,588464,313795,661201,620262,213262,714836,382329,671030,354076,576562,146961,483621,785904,51752,379464,329438,609988,97195,828691,177267,562079,22505,500065,15394,1047817,34186,951198,560826,104748,676429,297650,552610,607299,207355,319135,1034099,195683,51326,860040,360370,138079,471947,84648,529655,461831,119415,551013,543120,806374,462403,343083,770513,713717,109237,502979,870100) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000978s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 507581 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 507581 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000585s ]