SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001188s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 450442 LIMIT 1 [ RunTime:0.000390s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 450442 [ RunTime:0.001843s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (838597,513349,692109,358632,116217,846696,248653,658802,183911,510926,417426,28485,701500,24984,956692,115282,602853,9773,514436,956350,818570,240118,18034,346095,931643,556467,1009055,237526,100989,716165,605768,396949,356970,20321,352018,802343,901505,273118,551590,818197,904624,112389,536846,706474,420507,661988,883845,947666,314393,1045462,928055,584092,291952,290559,402095,226215,835746,909606,422541,384354) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001055s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 450442 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 450442 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000595s ]