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` = 527961 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 527961 [ RunTime:0.001712s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (286052,456141,223207,38111,545301,867216,189520,555099,63042,517526,740714,1032233,165264,955133,959476,200577,403140,1015666,366937,242276,736616,395224,445433,59106,551175,227934,738850,270331,22841,153483,94186,23226,1036987,199826,940947,164736,78502,53355,186768,947671,164538,589958,475394,861319,543329,514676,843637,460774,742710,90917,175134,499277,804185,138586,34372,281478,739791,1034682,496391,93193) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001003s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 527961 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000531s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 527961 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000775s ]