SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001302s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 39550 LIMIT 1 [ RunTime:0.000411s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 39550 [ RunTime:0.001577s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (620134,649683,241324,400078,433992,940977,661445,159749,867293,502223,464257,633112,253573,636385,912065,257784,892237,69763,760525,462222,923211,293497,704002,56400,179977,1025130,763946,226340,295507,864999,217882,493654,853231,655987,1019938,391719,1035140,417230,693822,10231,697961,289415,322581,1037121,476174,874550,732618,5286,638302,802943,748733,641177,707754,147853,911949,798798,462102,169695,121038,674698) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001185s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 39550 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000420s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 39550 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000616s ]