SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 201543 LIMIT 1 [ RunTime:0.000286s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 201543 [ RunTime:0.001778s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (279538,124844,690969,772967,157554,599863,1037099,516737,97082,862451,778916,822349,780870,706532,964846,391100,48410,987485,90106,51450,502633,956064,323812,76170,639046,970992,414109,153518,205576,456251,106068,824378,744427,358028,352070,40343,723325,681204,126643,755842,305338,335583,167080,671901,741770,771392,40039,37459,281145,583218,575193,553677,1036974,995828,449472,1044783,725930,5148,573194,55584) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001040s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 201543 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000428s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 201543 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000675s ]