SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001178s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 294628 LIMIT 1 [ RunTime:0.000427s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 294628 [ RunTime:0.001643s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (772832,124777,731276,793523,847419,195331,150773,960813,903375,828824,429446,953471,836409,589765,391513,205179,93240,419063,507170,1018186,309787,196717,460185,297628,494556,796132,53896,925224,276043,939276,622066,329909,335830,490533,551941,220907,315818,502155,237408,455098,163319,310497,192008,41665,336706,278403,325452,239215,837897,703872,750257,125361,1010894,999890,578674,536570,422919,778688,374176,303083) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001099s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 294628 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 294628 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002450s ]