SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001162s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 452616 LIMIT 1 [ RunTime:0.000314s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 452616 [ RunTime:0.001668s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (811435,665370,727498,318630,914499,641020,1010116,146119,833446,437980,660487,666754,785884,145768,119306,147956,436871,134486,307306,1018094,769113,449994,718964,566204,134834,780853,253388,179413,108995,561161,425267,670092,274352,123613,497566,112416,573443,170017,51268,828008,103985,12474,178217,57842,611028,525758,882254,17701,403331,483293,824860,814877,50617,771028,711071,529489,459917,499269,614074,364459) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001033s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 452616 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 452616 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000619s ]