SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001246s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 575420 LIMIT 1 [ RunTime:0.000335s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 575420 [ RunTime:0.002089s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (725757,64881,217736,52805,1023145,360527,619751,167388,449886,317261,128654,641679,590911,696454,560446,126273,1029658,303217,296128,372662,862972,720463,229421,92774,18625,43319,260057,857105,952118,131192,665201,370954,469670,910022,473529,547654,304873,488447,851275,101056,92673,363612,640294,927133,145110,819759,771274,281226,46916,53423,757939,540965,584853,40724,41311,756328,317693,713323,728179,538736) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001077s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 575420 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000422s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 575420 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000567s ]