SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001126s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 506919 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 506919 [ RunTime:0.001812s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (301915,980578,251351,255287,781851,589414,214495,1000003,522231,913249,246208,116930,734859,1012018,76485,540462,930928,434595,415394,334903,804477,14439,333688,520078,191084,278116,56271,838479,990596,721273,907317,422008,389764,965967,218377,365983,466153,675000,268678,518846,1016310,470280,668678,302357,11217,27103,714030,947462,1046330,523629,833735,978532,1044538,166372,832610,71138,639501,155014,238479,632390) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001284s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 506919 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000450s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 506919 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000433s ]