SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001135s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 425580 LIMIT 1 [ RunTime:0.000336s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 425580 [ RunTime:0.001709s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (497912,185111,534580,810702,672044,46384,594181,172315,459032,506,402469,379329,1023040,617252,190485,535075,774335,246877,967968,848442,309061,442096,287845,926884,943387,481034,934316,663049,168202,722166,120200,741519,604302,967003,888579,837931,1019535,889657,761031,879262,303359,614131,46374,985657,373981,37743,888416,346863,875336,185291,967774,984441,556652,588140,545498,756454,463406,727637,140866,979711) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001052s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 425580 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 425580 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000411s ]