SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001200s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1022862 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1022862 [ RunTime:0.001717s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (407449,496096,151057,145211,506424,984795,548141,468096,1008674,535873,954062,793656,825881,133659,988845,749012,628071,934412,402401,454223,463836,721802,433250,697533,854977,830838,84806,811668,885947,25308,495059,485154,390538,481018,147737,610667,793713,152948,351970,152539,674480,945310,93805,723903,492205,184507,508216,765923,843367,1016476,651693,424095,32698,444295,184769,360066,702155,598741,472891,301877) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000968s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1022862 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000343s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1022862 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000470s ]