SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001232s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 426505 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 426505 [ RunTime:0.001833s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (799978,389357,576033,541004,236625,1020207,117916,412989,882658,497108,480365,825103,256089,50913,953098,575123,364968,488423,382136,465209,416456,300050,932226,383929,417023,314555,204188,10286,175933,411845,444884,593082,28097,733526,452665,974934,692474,812718,263220,668678,266930,293992,61173,303231,869915,5928,226500,809101,471137,730753,23487,888841,637524,924717,606977,457768,29483,456489,517311,292881) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001297s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 426505 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000871s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 426505 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000831s ]