SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001230s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1007240 LIMIT 1 [ RunTime:0.000465s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1007240 [ RunTime:0.001965s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (470537,1042349,629170,199257,179684,855342,206842,692034,552910,658436,471164,629854,627214,968578,824135,910020,934734,914093,117642,164519,668490,4009,345262,860010,227547,253997,527100,954353,518995,858654,875405,570361,937052,73798,395534,651715,299399,475696,440370,1035654,626025,961947,402341,950527,404689,451032,46062,739464,356137,570966,779517,773776,307984,292953,559330,400335,56563,404494,467327,655392) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001204s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1007240 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000510s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1007240 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000601s ]