SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001345s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 211028 LIMIT 1 [ RunTime:0.000374s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 211028 [ RunTime:0.002857s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (161638,217965,976182,77067,749203,957961,572401,397813,430508,796050,302464,722843,103965,775076,1013968,421133,727407,435890,446687,468613,188344,132951,1030983,667696,723491,941348,702229,967213,764786,754392,1013830,313119,549625,418793,946189,129097,332083,168682,781335,242974,745729,416445,316695,398202,1007104,888388,286643,51427,790894,945010,653987,597933,394823,141592,149955,32065,490198,652512,116735,120196) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001209s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 211028 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 211028 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000761s ]