SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002639s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1005788 LIMIT 1 [ RunTime:0.001387s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1005788 [ RunTime:0.001970s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (118339,778134,11439,263385,32282,334815,743097,994071,709349,562601,731808,568842,36071,358458,704920,1032760,828893,43175,979849,445411,189535,1013199,1024623,130443,452359,534036,444033,132188,87337,252909,176386,400843,724283,48115,856136,514731,94987,170609,561995,16432,558573,164126,610047,91357,679134,988231,480985,299378,230505,120716,834560,37628,44592,331439,622547,47256,802783,505174,40223,1038366) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001071s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1005788 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000953s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1005788 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000548s ]