SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001165s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 802798 LIMIT 1 [ RunTime:0.000307s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 802798 [ RunTime:0.001812s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (311357,824620,53204,383220,50424,417717,340246,1006234,649514,422188,660567,131974,636891,607419,991482,1009119,396340,206247,130390,500902,82383,956575,544738,369665,298611,276114,993256,90733,743578,248382,353538,447384,70830,822700,384355,778208,62244,877339,89788,194676,759223,535646,682870,989692,904187,80411,688388,348628,294659,456079,253269,563467,337103,203039,713488,148807,992450,886234,988697,812883) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000990s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 802798 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 802798 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002985s ]