SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001191s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 412572 LIMIT 1 [ RunTime:0.000440s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 412572 [ RunTime:0.002912s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (510747,623274,389711,134563,174772,282416,762571,205052,964483,185040,122927,770482,209167,3869,46715,715363,520703,906701,380569,165914,422742,127812,574658,1048499,464968,312796,799363,732850,557145,307995,304894,27793,161282,432822,940910,212970,515294,674947,648995,834418,565595,377958,547450,712031,96010,848200,705775,372482,283549,1033393,3419,268606,799820,178604,105072,296701,493601,650066,1040748,755330) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002761s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 412572 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000401s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 412572 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000629s ]