SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001129s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 40810 LIMIT 1 [ RunTime:0.000307s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 40810 [ RunTime:0.001822s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (874152,161634,127469,369602,266698,712994,1035181,895938,216121,550117,101053,227467,427228,778881,399085,353160,287729,176694,482997,94305,16522,981837,988530,306975,559929,638806,972439,271027,367263,891925,902107,714575,96994,220578,900237,283201,786655,174596,309585,746224,509753,40830,954575,849750,133438,748048,458286,670931,26811,884888,700028,682929,992405,307709,901521,797041,120045,694147,953159,381309) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001060s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 40810 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000419s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 40810 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000567s ]