SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 445504 LIMIT 1 [ RunTime:0.000319s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 445504 [ RunTime:0.001909s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (571438,210318,442420,706808,913401,513639,252762,736261,925961,403873,381117,891580,135487,1027436,93435,458865,101091,820247,92801,340150,255483,621872,215467,910824,806219,367494,171005,802320,251780,173521,842636,379955,855717,804943,887559,147883,285801,726646,331504,840819,637087,659278,829056,211946,690855,551287,1039238,958720,459107,90576,955398,629108,948824,605825,963097,626093,373292,383582,924958,839561) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000960s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 445504 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000327s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 445504 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000433s ]