SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001188s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 20178 LIMIT 1 [ RunTime:0.000304s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 20178 [ RunTime:0.002044s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1004515,197994,948966,634676,563921,268317,952319,368367,361676,326584,860416,573392,544440,517374,225365,1008502,868126,912994,208144,480600,568528,844155,830233,234718,832565,716377,710740,10493,108286,343399,633916,782752,606757,951947,305522,229926,716758,925283,411948,237397,396429,72011,884454,552510,89421,729390,167255,970203,717690,407592,836371,819331,273228,793901,389102,60568,407720,886090,554266,764167) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001748s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 20178 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000422s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 20178 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000615s ]