SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001116s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 149035 LIMIT 1 [ RunTime:0.000373s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 149035 [ RunTime:0.001966s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (952604,371462,848180,505033,108941,1016289,865575,1041010,200932,446586,1036454,278977,837578,478838,457462,922728,673145,67539,453447,1010970,1033049,542352,447903,982984,656435,60289,860912,256103,1046823,204122,345201,251073,848929,1046447,384645,738293,920676,134150,986275,810517,786698,48494,352988,957682,810201,924976,270626,1029059,698245,165858,539916,394227,710409,100119,540,657076,95600,773794,670155,137186) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000958s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 149035 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 149035 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000488s ]