SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001130s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 409100 LIMIT 1 [ RunTime:0.000384s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 409100 [ RunTime:0.002256s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (888811,170282,334320,727435,951030,242054,845975,382188,1044708,153207,44665,518168,854572,751317,620776,960995,654463,967311,161797,134030,150163,409791,537752,623361,602948,492260,589575,128349,906490,1014461,74701,499904,985690,206390,632718,540478,615951,137524,699309,100266,934652,125483,685068,78683,154275,446614,646056,5945,489523,377245,596937,569032,215219,912666,556799,565048,338692,702551,228339,377713) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001420s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 409100 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000596s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 409100 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000646s ]