SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001191s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 545603 LIMIT 1 [ RunTime:0.000327s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 545603 [ RunTime:0.001910s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (775934,95031,322998,574368,39939,151727,471931,172602,856693,50224,211482,1008376,363856,64849,141813,1040714,918626,892917,453412,235850,702114,177878,112875,699751,775085,417334,527685,589580,102115,1016420,651724,13704,767718,546225,760899,551402,712180,847219,397182,943203,169723,48454,332601,967640,738558,719761,220902,588824,511702,370809,546669,404758,245472,145467,651567,837737,283114,412084,403036,206449) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003448s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 545603 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000552s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 545603 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001148s ]