SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001245s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 54143 LIMIT 1 [ RunTime:0.000993s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 54143 [ RunTime:0.002586s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (158609,719985,252686,979224,522861,78219,412685,933573,707919,1002177,709992,816374,322118,712660,952956,731433,774326,51545,376170,668531,161444,1008596,380360,684530,628406,334723,304904,889080,657512,282317,495356,684962,983953,337500,462944,620406,761442,359267,710124,388713,513964,673841,231535,374580,165259,34827,169070,849750,312753,184227,775327,233905,181816,112693,225146,852111,459888,910730,60097,161285) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.010807s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 54143 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000630s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 54143 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002999s ]