SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001300s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 502748 LIMIT 1 [ RunTime:0.000362s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 502748 [ RunTime:0.002317s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (593277,451527,553878,38731,866977,1000642,82095,534195,64982,375452,910863,175598,822449,1044579,40835,680030,241801,841180,425179,161063,375322,892524,849572,532295,60563,1027779,492050,339912,983261,280343,514012,693942,362872,942968,128169,1026771,528422,733634,961637,251812,581829,708599,538311,902438,422085,967523,816527,872340,347445,372500,1034898,391857,156325,643094,250842,348452,152773,968923,315494,819014) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000990s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 502748 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 502748 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000517s ]