SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.006679s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1025006 LIMIT 1 [ RunTime:0.001150s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1025006 [ RunTime:0.006664s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1027066,590186,101144,925109,588363,564780,61575,906023,81001,547343,855975,391714,578083,70715,597304,875759,749753,457268,360557,820217,994215,608453,408201,132321,1726,214215,738932,106690,165039,579510,8526,753249,234566,569841,355521,27720,1043680,712126,913980,1020910,899425,547532,999602,485954,26173,386681,524814,568370,426673,21982,909360,365605,151208,151175,7521,92095,1034760,846405,445207,153202) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001198s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1025006 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1025006 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000989s ]