SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001247s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501249 LIMIT 1 [ RunTime:0.000398s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501249 [ RunTime:0.002982s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (6782,443664,505359,558329,775327,111965,403924,178047,862946,275031,278540,793066,623544,412360,471166,88875,841839,824304,433168,533464,3128,116120,554762,314379,917789,391057,109127,1023761,342463,282133,892814,292476,218776,977759,481186,855757,472199,463009,155734,142262,1018711,414609,266000,422771,45123,548467,723898,547998,673799,444522,317847,236380,39496,75072,86043,86944,14390,701451,649662,893610) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501249 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000445s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501249 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000721s ]