SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001098s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 503965 LIMIT 1 [ RunTime:0.000314s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 503965 [ RunTime:0.001489s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (368450,341293,435326,665734,752963,458372,947082,990201,872492,783902,446281,297480,1002916,973153,63293,140926,379338,841940,951514,278990,735549,734582,108014,639437,25781,665754,733924,263737,279893,51266,601676,283207,346561,533820,257859,413552,241401,804863,764961,20438,982444,71525,230139,458786,260657,663667,111767,7040,305536,161212,803256,359222,138966,749072,302939,471126,296005,772300,680123,451510) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003222s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 503965 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000970s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 503965 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000506s ]