SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001099s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 174209 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 174209 [ RunTime:0.001588s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (523134,930537,109066,880493,674507,410060,255299,253830,108922,639250,397510,358674,384151,751310,625228,651695,1034816,777296,90603,348991,1014689,309309,972819,330323,116696,965059,994270,80308,402256,718563,409223,262791,434841,954785,721491,326556,170571,846033,774091,106464,782047,369453,584125,721604,477646,431564,116999,713414,832486,372050,18984,557476,836407,1018828,971384,303595,1020749,858366,592800,586273) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001215s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 174209 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 174209 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000434s ]