SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001309s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 564846 LIMIT 1 [ RunTime:0.000528s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 564846 [ RunTime:0.002340s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (134493,840977,298111,464788,838653,213742,897613,638518,142581,730773,69842,482607,17251,375890,750416,582693,470578,401141,679172,483165,544829,912463,1035564,407456,252827,678030,76306,64008,213340,506279,439599,896288,490478,1012876,281535,144770,748993,846294,656403,235582,594162,191972,188658,25608,612446,159680,741216,707777,171793,873807,24576,287659,792425,581976,706862,334315,449846,674786,83589,772863) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001145s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 564846 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 564846 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000610s ]