SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001328s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 102084 LIMIT 1 [ RunTime:0.001028s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 102084 [ RunTime:0.003093s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (552482,867570,819972,885603,350304,111318,840365,286823,445634,785206,670989,901380,607937,840369,758472,805020,1008652,381783,629258,821178,178686,354384,809409,277436,143327,183218,1008517,353547,65913,1042862,518026,243883,18104,327101,781913,587697,768515,1048129,728582,883042,782434,899690,951966,36232,809046,540706,672733,646529,921206,485451,687901,48430,510735,757596,819784,694240,416942,190503,343116,343982) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001153s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 102084 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000497s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 102084 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000581s ]