SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001136s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 982833 LIMIT 1 [ RunTime:0.000489s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 982833 [ RunTime:0.003889s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (488293,178967,183054,912411,549113,545287,241992,648245,1399,331835,825914,494894,444090,169880,316808,920920,55590,157537,1041904,110167,165803,890715,595019,682841,65678,123672,311168,353666,957616,341831,244632,749705,445120,1004563,77286,38543,870425,505783,317508,11360,974072,945768,219591,291697,569645,40566,79042,73045,193841,761390,143795,182783,113956,6887,931080,71480,753736,464243,34622,328912) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002239s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 982833 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 982833 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000526s ]