SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002113s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 492212 LIMIT 1 [ RunTime:0.000421s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 492212 [ RunTime:0.001762s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1018130,190447,967268,290333,120352,317333,65797,991130,319524,929191,274530,962301,432707,741619,258870,670835,657737,278271,645083,792708,493018,89856,68774,782371,324300,883052,966272,345247,244266,476707,667029,404482,879889,306419,11864,191857,401191,384366,874368,627784,16421,10423,474490,699216,950196,352771,180899,60763,244690,676221,683895,220057,684089,923922,339899,547414,1043698,365088,688540,148382) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004476s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 492212 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000933s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 492212 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000384s ]